package com.app.TCES.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.app.TCES.domain.Administrator;
import com.app.TCES.domain.Student;
import com.app.TCES.domain.Teacher;

@Mapper
public interface UserMapper {
	
    @Select("select * from administrator where adminId = #{administrator.adminId} and password = #{administrator.password}")
	public Administrator selectAdministrator(@Param("administrator")Administrator administrator) ;
    
    @Select("select * from student where stuId = #{student.stuId} and password = #{student.password}")
	public Student selectStudent(@Param("student")Student student);
    
    @Select("select * from teacher where tchId = #{teacher.tchId} and password = #{teacher.password}")
	public Teacher selectTeacher(@Param("teacher")Teacher teacher);
    
    
    
    
}
